Re: problem with transactions in VB.NET using npgsql - Mailing list pgsql-general

From Owen Hartnett
Subject Re: problem with transactions in VB.NET using npgsql
Date
Msg-id p06230904c2f9de183e5a@[192.168.0.102]
Whole thread Raw
In response to Re: problem with transactions in VB.NET using npgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: problem with transactions in VB.NET using npgsql
List pgsql-general
At 7:05 PM -0400 8/27/07, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>>  I assign the transaction object to each of the commands, but it seems
>>  that some tables will get updated, even when I call rollback.  Is
>>  something I'm calling secretly calling "commit" somewhere?
>
>Dunno anything about vb.net, but this sounds like an autocommit feature
>that's not doing what you expect.
>
>If nothing else comes to mind, try setting the DB to log all statements
>(see log_statement), and compare the resulting trace to what you think
>your code is doing.  That should at least narrow it down a lot.
>
>            regards, tom lane

Thanks, I'll give that a try.

-Owen

pgsql-general by date:

Previous
From: "Keaton Adams"
Date:
Subject: Turning off atime on PostgreSQL DB volumes
Next
From: Bill Moran
Date:
Subject: Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)